Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
By jetro44 on
I have playlist (views) , where i can see thumnails from different sources. I have two fields (colums): content_image_upload and youtube_thumbnail (different sources). I need to merge this two colums into one. If is any way how to solve this issue, pls help.
Check my link bellow for better info.
http://img861.imageshack.us/i/2to1.jpg/
Thanks for any help.
Comments
In the view's settings where
In the view's settings where you set the display to 'Table' there should be a gear icon. Click on the gear icon and that should bring up the options to combine fields into a single column.
Hope this helps!
-= Gerrit Brands
PROBLEM SOLVED: Check
PROBLEM SOLVED:
Check "Exclude from display" in first field and in second field "Rewrite the output of this field" and write tokens of fields (for my solution: [field_image_fid] and [field_emfield_embed] )
http://img858.imageshack.us/i/merge2in1.jpg/
tramtadaaaa
this solution is good.
this solution is good.
Very useful!
Very useful! I want to combine as many as 6 fields into one column, putting pairs together with a comma then separating the pairs with linebreak. I can get the pairing to work but you can only pair with a field that's "gone before", meaning you must hide the first column and put your combination code into Rewrite field of the second.
However, if you hide the first column, you also hide its column heading. To get the column heading back, edit your second field, add a Custom column heading, then go back to the gear icon next to Style: Table and use the selectors to pick the heading of the second field to make all your fields appear in the same column.
Web application developer
http://kmi.open.ac.uk/
Thanks
This solution worked for me. Thanks for sharing.
The simplest way
The simplest way here:
http://stackoverflow.com/a/1230244/919489
This solution worked for me.
This solution worked for me. Thanks a lot :)
I'm not able to get the
I'm not able to get the desired output after trying the above steps. Please find my views code.
$view = new view;
$view->name = 'show_case';
$view->description = '';
$view->tag = 'default';
$view->base_table = 'node';
$view->human_name = 'Show case';
$view->core = 7;
$view->api_version = '3.0';
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */
/* Display: Master */
$handler = $view->new_display('default', 'Master', 'default');
$handler->display->display_options['title'] = 'Show case';
$handler->display->display_options['access']['type'] = 'perm';
$handler->display->display_options['cache']['type'] = 'none';
$handler->display->display_options['query']['type'] = 'views_query';
$handler->display->display_options['query']['options']['query_comment'] = FALSE;
$handler->display->display_options['exposed_form']['type'] = 'basic';
$handler->display->display_options['pager']['type'] = 'full';
$handler->display->display_options['pager']['options']['items_per_page'] = '10';
$handler->display->display_options['style_plugin'] = 'table';
/* Relationship: Content: Referenced product */
$handler->display->display_options['relationships']['field_product_product_id']['id'] = 'field_product_product_id';
$handler->display->display_options['relationships']['field_product_product_id']['table'] = 'field_data_field_product';
$handler->display->display_options['relationships']['field_product_product_id']['field'] = 'field_product_product_id';
$handler->display->display_options['relationships']['field_product_product_id']['label'] = 'Referenced Product';
$handler->display->display_options['relationships']['field_product_product_id']['required'] = 1;
/* Field: Field: Image */
$handler->display->display_options['fields']['field_image']['id'] = 'field_image';
$handler->display->display_options['fields']['field_image']['table'] = 'field_data_field_image';
$handler->display->display_options['fields']['field_image']['field'] = 'field_image';
$handler->display->display_options['fields']['field_image']['relationship'] = 'field_product_product_id';
$handler->display->display_options['fields']['field_image']['label'] = '';
$handler->display->display_options['fields']['field_image']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_image']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_image']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['field_image']['alter']['external'] = 0;
$handler->display->display_options['fields']['field_image']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['field_image']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['field_image']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['field_image']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_image']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_image']['alter']['more_link'] = 0;
$handler->display->display_options['fields']['field_image']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_image']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_image']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_image']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['field_image']['element_default_classes'] = 1;
$handler->display->display_options['fields']['field_image']['hide_empty'] = 0;
$handler->display->display_options['fields']['field_image']['empty_zero'] = 0;
$handler->display->display_options['fields']['field_image']['hide_alter_empty'] = 1;
$handler->display->display_options['fields']['field_image']['click_sort_column'] = 'fid';
$handler->display->display_options['fields']['field_image']['settings'] = array(
'image_style' => 'thumbnail',
'image_link' => '',
);
$handler->display->display_options['fields']['field_image']['field_api_classes'] = 0;
/* Field: Content: Title */
$handler->display->display_options['fields']['title']['id'] = 'title';
$handler->display->display_options['fields']['title']['table'] = 'node';
$handler->display->display_options['fields']['title']['field'] = 'title';
$handler->display->display_options['fields']['title']['label'] = '';
$handler->display->display_options['fields']['title']['alter']['alter_text'] = 1;
$handler->display->display_options['fields']['title']['alter']['text'] = 'Commerce Product: SKU';
$handler->display->display_options['fields']['title']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['title']['alter']['absolute'] = 1;
$handler->display->display_options['fields']['title']['alter']['external'] = 0;
$handler->display->display_options['fields']['title']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['title']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['title']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['title']['alter']['word_boundary'] = 0;
$handler->display->display_options['fields']['title']['alter']['ellipsis'] = 0;
$handler->display->display_options['fields']['title']['alter']['more_link'] = 0;
$handler->display->display_options['fields']['title']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['title']['alter']['trim'] = 0;
$handler->display->display_options['fields']['title']['alter']['html'] = 0;
$handler->display->display_options['fields']['title']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['title']['element_default_classes'] = 1;
$handler->display->display_options['fields']['title']['hide_empty'] = 0;
$handler->display->display_options['fields']['title']['empty_zero'] = 0;
$handler->display->display_options['fields']['title']['hide_alter_empty'] = 1;
$handler->display->display_options['fields']['title']['link_to_node'] = 1;
/* Field: Commerce Product: SKU */
$handler->display->display_options['fields']['sku']['id'] = 'sku';
$handler->display->display_options['fields']['sku']['table'] = 'commerce_product';
$handler->display->display_options['fields']['sku']['field'] = 'sku';
$handler->display->display_options['fields']['sku']['relationship'] = 'field_product_product_id';
$handler->display->display_options['fields']['sku']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['sku']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['sku']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['sku']['alter']['external'] = 0;
$handler->display->display_options['fields']['sku']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['sku']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['sku']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['sku']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['sku']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['sku']['alter']['more_link'] = 0;
$handler->display->display_options['fields']['sku']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['sku']['alter']['trim'] = 0;
$handler->display->display_options['fields']['sku']['alter']['html'] = 0;
$handler->display->display_options['fields']['sku']['element_label_colon'] = 1;
$handler->display->display_options['fields']['sku']['element_default_classes'] = 1;
$handler->display->display_options['fields']['sku']['hide_empty'] = 0;
$handler->display->display_options['fields']['sku']['empty_zero'] = 0;
$handler->display->display_options['fields']['sku']['hide_alter_empty'] = 1;
$handler->display->display_options['fields']['sku']['link_to_product'] = 0;
/* Field: Commerce Product: Price */
$handler->display->display_options['fields']['commerce_price']['id'] = 'commerce_price';
$handler->display->display_options['fields']['commerce_price']['table'] = 'field_data_commerce_price';
$handler->display->display_options['fields']['commerce_price']['field'] = 'commerce_price';
$handler->display->display_options['fields']['commerce_price']['relationship'] = 'field_product_product_id';
$handler->display->display_options['fields']['commerce_price']['label'] = '';
$handler->display->display_options['fields']['commerce_price']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['commerce_price']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['commerce_price']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['commerce_price']['alter']['external'] = 0;
$handler->display->display_options['fields']['commerce_price']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['commerce_price']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['commerce_price']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['commerce_price']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['commerce_price']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['commerce_price']['alter']['more_link'] = 0;
$handler->display->display_options['fields']['commerce_price']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['commerce_price']['alter']['trim'] = 0;
$handler->display->display_options['fields']['commerce_price']['alter']['html'] = 0;
$handler->display->display_options['fields']['commerce_price']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['commerce_price']['element_default_classes'] = 1;
$handler->display->display_options['fields']['commerce_price']['hide_empty'] = 0;
$handler->display->display_options['fields']['commerce_price']['empty_zero'] = 0;
$handler->display->display_options['fields']['commerce_price']['hide_alter_empty'] = 1;
$handler->display->display_options['fields']['commerce_price']['click_sort_column'] = 'amount';
$handler->display->display_options['fields']['commerce_price']['type'] = 'commerce_price_formatted_amount';
$handler->display->display_options['fields']['commerce_price']['settings'] = array(
'calculation' => '0',
);
$handler->display->display_options['fields']['commerce_price']['field_api_classes'] = 0;
/* Field: Commerce Product: Add to Cart form */
$handler->display->display_options['fields']['add_to_cart_form']['id'] = 'add_to_cart_form';
$handler->display->display_options['fields']['add_to_cart_form']['table'] = 'commerce_product';
$handler->display->display_options['fields']['add_to_cart_form']['field'] = 'add_to_cart_form';
$handler->display->display_options['fields']['add_to_cart_form']['relationship'] = 'field_product_product_id';
$handler->display->display_options['fields']['add_to_cart_form']['label'] = '';
$handler->display->display_options['fields']['add_to_cart_form']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['add_to_cart_form']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['add_to_cart_form']['alter']['absolute'] = 0;
$handler->display->display_options['fields']['add_to_cart_form']['alter']['external'] = 0;
$handler->display->display_options['fields']['add_to_cart_form']['alter']['replace_spaces'] = 0;
$handler->display->display_options['fields']['add_to_cart_form']['alter']['trim_whitespace'] = 0;
$handler->display->display_options['fields']['add_to_cart_form']['alter']['nl2br'] = 0;
$handler->display->display_options['fields']['add_to_cart_form']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['add_to_cart_form']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['add_to_cart_form']['alter']['more_link'] = 0;
$handler->display->display_options['fields']['add_to_cart_form']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['add_to_cart_form']['alter']['trim'] = 0;
$handler->display->display_options['fields']['add_to_cart_form']['alter']['html'] = 0;
$handler->display->display_options['fields']['add_to_cart_form']['element_label_colon'] = FALSE;
$handler->display->display_options['fields']['add_to_cart_form']['element_default_classes'] = 1;
$handler->display->display_options['fields']['add_to_cart_form']['hide_empty'] = 0;
$handler->display->display_options['fields']['add_to_cart_form']['empty_zero'] = 0;
$handler->display->display_options['fields']['add_to_cart_form']['hide_alter_empty'] = 1;
$handler->display->display_options['fields']['add_to_cart_form']['show_quantity'] = 0;
$handler->display->display_options['fields']['add_to_cart_form']['default_quantity'] = '1';
$handler->display->display_options['fields']['add_to_cart_form']['combine'] = 1;
$handler->display->display_options['fields']['add_to_cart_form']['display_path'] = 0;
$handler->display->display_options['fields']['add_to_cart_form']['line_item_type'] = 0;
/* Sort criterion: Content: Title */
$handler->display->display_options['sorts']['title']['id'] = 'title';
$handler->display->display_options['sorts']['title']['table'] = 'node';
$handler->display->display_options['sorts']['title']['field'] = 'title';
$handler->display->display_options['sorts']['title']['order'] = 'DESC';
/* Filter criterion: Content: Published */
$handler->display->display_options['filters']['status']['id'] = 'status';
$handler->display->display_options['filters']['status']['table'] = 'node';
$handler->display->display_options['filters']['status']['field'] = 'status';
$handler->display->display_options['filters']['status']['value'] = 1;
$handler->display->display_options['filters']['status']['group'] = 1;
$handler->display->display_options['filters']['status']['expose']['operator'] = FALSE;
/* Filter criterion: Content: Type */
$handler->display->display_options['filters']['type']['id'] = 'type';
$handler->display->display_options['filters']['type']['table'] = 'node';
$handler->display->display_options['filters']['type']['field'] = 'type';
$handler->display->display_options['filters']['type']['value'] = array(
'product_display' => 'product_display',
);
/* Display: Page */
$handler = $view->new_display('page', 'Page', 'page');
$handler->display->display_options['path'] = 'show-case';