split

[raadwiptec]

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

[sarvesh]

Please refer below mentioned link:

Splitting a field into multiple fields‌

Regard's

Sarvesh Srivastava

[ecolomer]

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)

[Anil_Babu_Samineni]

Or

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)