Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to combine multiple fields in to one
eg:
product
customer
amount
these 3 in to a field called as Details how can it be done where in then the details field will have product, customer and amount as field values?
You can use product&customer&amount
the & is a concatenation function. Also you may use Concat
Returns the aggregated string concatenation of all values of expression iterated over the chart dimension(s). Each value may be separated by the string found in delimiter. The order of concatenation may be determined by sort-weight. Sort-weight should return a numeric value where the lowest value will render the item to be sorted first.
concat( Code, ';' )
concat( FirstName&' '&LastName, ',' )
concat( distinct Code, ';' )
concat( total Name, ';' , Date )
concat( total <Grp> Name, ';' , Date)
let me show you an example,
Product | Customer | order |
prod 1 | name 1 | order1 |
prod 2 | name2 | order2 |
prod 3 | name3 | order3 |
then my result column will have
Details |
Product |
Customer |
Order |
details will get the product, customer and order which in turn have their values from past table.
HI,
Try this
LOAD
Product,
Order,
Customer,
Product & Order & Customer AS Details
FROM SourceData;
Hope this what you are expecting.
Regards,
jagan.