Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Below is a bundle that has been broken out. Unfortunately, if a bundle is not broken out you cannot see the item of the individual items under that bundle. The first picture is what I have currently in my report. How can I make it into the second picture?
Is there a way I can transform the data into this below:
Sort Line Number in ascending order.You can hide related line no column as well. What table is it?
Thank you!
Thanks for the reply! But that wouldn't work since the Line number can be reused. To make it unique I would have to use the Order Number and Invoice number. I guess my example wasn't very clear.
Can you share your data or app?
Thank you!
Hello Neena,
According to what I have interpreted your data to be, the logic would be
Transform:
NoConcatenate
LOAD Distinct
Item,
NUM([Line Number]) as [Line Number],
//[Related Line Number],
Price
Resident Input;
Left Join(Transform)
LOAD Distinct
Item,
NUM([Related Line Number]) as [Line Number],
Price
Resident Input;
DROP Table Input;
Please find the attach qvw for the same. Please provide more data if this doesn't suite your need.
Thanks
Vamsee
Hi Ishtdeep, Sorry I can't share my qvw but I have attached a sample of data. You can see that there are the same line number used over again and to make it unique is the order number. Anything with a 0 means it is the Parent/Bundle. It also won't always say Bundle it can have any name but what will always stay the same is a 0 value for the invoice number.
Hi Neena,
Make sure you follow the proper sorting of the numeric fields.check out the attached.