Interno and Resident

[reporting_neu]

Hello,

how can I use "Interno" and "Resident" together in this Script?

The field "ANZuordnung_Valid_until" was previously created, so the table (TMP2) already exists.

NoConcatenate
Orga_AN_Zuord:
LOAD
	OrgID, 
	MDNr, 
	ANNr, 
    Status,
    1 as valid,
    Date(ANZuordnung_Valid_from + IterNo()-1) as NewDate While Date(ANZuordnung_Valid_from+IterNo()-1)<=if(isnull(ANZuordnung_Valit_until), today(), ANZuordnung_Valid_until)
Resident TMP2;

 Can you help me please?

[vinieme12 · Accepted solution]

refer this blog for more

https://community.qlik.com/t5/Member-Articles/Generating-Missing-Data-In-QlikView/ta-p/1491394

Orga_AN_Zuord:
LOAD
	OrgID, 
	MDNr, 
	ANNr, 
    Status,
    1 as valid,
    Date(ANZuordnung_Valid_from + IterNo()-1) as NewDate 
Resident TMP2
While Date(ANZuordnung_Valid_from+IterNo()-1)<=date(if(isnull(ANZuordnung_Valit_until), today(), ANZuordnung_Valid_until));

[reporting_neu]

Thank you so much! 🙂