Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI Team,
could you please help me out with the below requirement
input table :
product ,quantity
AC,2
TyV,3
EXPECTED OUTPUT AS BELOW:
product,quantity
AC,1
AC,1
TV,1
TV,1
TV,1
Thanks in advance
regards
siva
Try like:
Load
product,
1 as quantity
While IterNo() <=quantity;
Load * Inline [
product ,quantity
AC,2
TV,3]
Try like:
Load
product,
1 as quantity
While IterNo() <=quantity;
Load * Inline [
product ,quantity
AC,2
TV,3]
HI Tresesco,
sorry for the late response
the above mentioned script working as per my requirement.
in table viewer it showing as expected but when i Create a table box in front end its showing wrongly
please find the below table viewer and table box screen shots
Thanks
siva
Table box shows only the unique values. But the records will be there. If you use Count(quality), you could see the count of records.
@...a table box in front end its showing wrongly
No, table box is showing only the unique combination of records/rows and that is how it is designed. So don't worry about the number of records seeing in the table box. Do your calculations, it would work as expected.
Hi Tresesco,
thank you for your prompt response
i understood the behavior of table box , is there any way in qlik, we can show in front end as we saw duplicate records in table viewer
thanks
siva
If you want to show the Duplicates, add RowNo() As RowID. Bring this in the Table
Hi Saran,
thank you its working
Thanks
siva