Hi,I have data likeNo:111Name:aaaaNo:222Name:bbbNo:333Name:cccNo:444Name:dddThe result, I needNoName111aaaa222bbb333ccc444dddHope someone help meThanks

like this?tmp:load rowno() as Id, subfield(row, ':', 2) as Field inline [rowNo:111Name:aaaaNo:222Name:bbbNo:333Name:cccNo:444Name:ddd];final:load Id, Field as No Resident tmp where Odd(Id);join (final) load Id -1 as Id, Field as Name Resident tmp where not Odd(Id); drop table tmp;

If you got what you wanted, please mark Massimo's answer as correct answer to close this thread.Best,Sunny

Now its working .Thanks to allPav

I have external notepad file having data like No:111Name:aaaaNo:222Name:bbbNo:333Name:cccNo:444Name:dddetc.....I have to load all data into table.The table with columns likeNo,Name111,aaaa222,bbb..etc....if we give the notepad file path, The data should loaded automatically and generate the table as I expected.Thanks

Why do you need to loop, why can't you do a simple load? Is data structured in a way that a regular load won't work? You need to provide some details in order to get what you are looking for.Best,Sunny

if we have thousand of rows, for example:Loop through from first line to endLoop starttake No(111)take NameLoop end(aaaa)after 222 etc..

Not sure I understand what you mean. Can you elaborate your requirement?

I need to loop through the data automaticaly

Script:Table:LOAD * Inline [No., Name111, aaaa222, bbb333, ccc444, ddd];Output:

Create script table

Qlik.com | Qlik Services | Qlik Help

Ask a Question

Hi,

I have data like

No:111

Name:aaaa

No:222

Name:bbb

No:333

Name:ccc

No:444

Name:ddd

The result, I need

No	Name
111	aaaa
222	bbb
333	ccc
444	ddd

Hope someone help me

Thanks

11 Replies

Author

I have done

Thank you Pavendhan‌

Create script table

QlikView App Dev

Related Topics