topic Re: Create script table in QlikView

Create script table

pavendhan — Fri, 19 Jun 2015 12:59:34 GMT

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

Re: Create script table

sunny_talwar — Fri, 19 Jun 2015 15:48:30 GMT

Script:

Table:

LOAD * Inline [

No., Name

111, aaaa

222, bbb

333, ccc

444, ddd

];

Output:

Re: Create script table

pavendhan — Tue, 23 Jun 2015 14:40:36 GMT

I need to loop through the data automaticaly

Re: Create script table

sunny_talwar — Tue, 23 Jun 2015 14:42:01 GMT

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

Re: Create script table

pavendhan — Tue, 23 Jun 2015 14:49:42 GMT

if we have thousand of rows,

for example:

Loop through from first line to end

Loop start

take No(111)

take Name

Loop end(aaaa)

after 222 etc..

Re: Create script table

sunny_talwar — Tue, 23 Jun 2015 14:52:10 GMT

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

Re: Create script table

pavendhan — Tue, 23 Jun 2015 15:04:14 GMT

I have external notepad file having data like

No:111

Name:aaaa

No:222

Name:bbb

No:333

Name:ccc

No:444

Name:ddd

etc.....

I have to load all data into table.

The table with columns like

No,Name

111,aaaa

222,bbb

etc....

if we give the notepad file path, The data should loaded automatically and generate the table as I expected.

Thanks

Re: Create script table

maxgro — Tue, 23 Jun 2015 15:04:27 GMT

like this?

tmp:

load rowno() as Id, subfield(row, ':', 2) as Field inline [

row

No:111

Name:aaaa

No:222

Name:bbb

No:333

Name:ccc

No:444

Name: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;

Re: Create script table

pavendhan — Tue, 23 Jun 2015 15:12:07 GMT

Now its working .

Thanks to all

Pav

Re: Create script table

sunny_talwar — Tue, 23 Jun 2015 15:18:30 GMT

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

Best,

Sunny

Re: Create script table

pavendhan — Tue, 23 Jun 2015 15:22:10 GMT

I have done

Re: Create script table

sunny_talwar — Tue, 23 Jun 2015 15:23:12 GMT

Thank you Pavendhan‌