Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have a table with some product numbers and some other fields displayed in straight table.
i have to display three names consecutively across each product numbers. how will i do this? please help me with the expression
for example , if i have the names John, Abbie, Emma. My output should be like below:
Product No | Username |
30494 | John |
30677 | Abbie |
31086 | Emma |
31742 | John |
40005 | Abbie |
40726 | Emma |
41675 | John |
Something like:
if(RowNo()/2 = Floor(RowNo()/2).'Abbie'.
if(RowNo()/3 = Floor(RowNo()/3).'Emma.'John')) as UserName;
Something like:
if(RowNo()/2 = Floor(RowNo()/2).'Abbie'.
if(RowNo()/3 = Floor(RowNo()/3).'Emma.'John')) as UserName;
Could you please let me know how the input data will be
Your requirement is not clear , you are wanted to show customers/users for each product rite ? but in the example your product ID is different for all the users ..not user how your data looks like , could you share a sample data set and required output so that we could try to help
Thank you so much