topic Re: split in QlikView

split

raadwiptec — Wed, 25 Nov 2020 16:16:04 GMT

I have a source where i need to split the file.. for ex

invoice

invoice rate

invoice type

etc...

if the invoice type is PRS then Load

if the invoice type is LSS then Load..

I need to split the data and further put the values in 2 columsn

Re: split

sarvesh — Sat, 18 Mar 2017 11:02:45 GMT

Please refer below mentioned link:

Splitting a field into multiple fields‌

Regard's

Sarvesh Srivastava

Re: split

ecolomer — Sat, 18 Mar 2017 11:05:09 GMT

Hi,

You can load all records in the first round.

TEMP:

LOAD *

SQL Select ....

PRS:

LOAD *

resident TEMP where type = 'PRS';

STORE PRS.qvd (qvd);

LSS:

LOAD *

resident TEMP ehere type='LSS';

STORE LSS.qvd (qvd);

DROP TABLE TEMP;

And you have 2 files (PRS.qvd and LSS.qvd)

Re: split

Anil_Babu_Samineni — Sun, 19 Mar 2017 03:17:00 GMT

TEMP:

LOAD *, 'PRS' as Flag

SQL Select ....

TEMP:

LOAD *, 'LSS' as Flag

SQL Select ....

Then use Field called Flag where in Front end or Background. This will very helpful instead of split. This can used and helps for better in condition(May be set operator)