I have product code ,product name
expected output should be follows
product code,product name
Is this something you want in the script or front end? For front end, try this
One way of doing is to use Mapping and ApplyMap () function in Data load script using a Flag as shown below.
Then add the dimension (Object) and Measure (If(Flag = 1, Value, NULL)). And exclude the NULL values.
Note: This is sample method, you can also try different options.
only one value getting for all products
Which approach did you try?