topic Re: creating a table detail from table in Qlik Automate

creating a table detail from table

doespirito — Mon, 29 Jan 2024 14:38:52 GMT

Hello,
From a table 1, which contains a list of journals and a field representing the number of pages of these journals, I wish to create a table 2 which contains for each journal 1 record per page with a numbering of these pages.
I tried with the peek function but I can't do it.
can you help me?
THANKS
Arnault

Re: creating a table detail from table

Or — Tue, 30 Jan 2024 08:03:40 GMT

I'm not sure what the pages are supposed to represent, but if you're trying to create N records per original record, have a look at using Load ... While with IterNo(), e.g.

Load A, B, C, IterNo() as D From SomeTable

While IterNo() <C;

https://help.qlik.com/en-US/qlikview/May2023/Subsystems/Client/Content/QV_QlikView/Scripting/CounterFunctions/IterNo.htm

Re: creating a table detail from table

Nagaraju_KCS — Mon, 29 Jan 2024 15:12:40 GMT

Try this

LOAD Date,
MediaSAP,
EditionSAP,
NBPagesSAP2,
IterNo() as Sequence
FROM
[C:\Data.xlsx](ooxml, embedded labels, table is Sheet3)
while IterNo() <=NBPagesSAP2;

Re: creating a table detail from table

doespirito — Mon, 29 Jan 2024 16:00:11 GMT

Thank you so much.
it works great with iterno() and while.
Good day !

Re: creating a table detail from table

doespirito — Mon, 29 Jan 2024 16:03:08 GMT

Thank you for taking the time to respond to me. I used the first solution and I will try to test yours