Data Load

[#1]

Hi All,

I have data something like below

Order Number	Header_text	LineNo
16-101003	Inclusive of VAT@ 14.5%, Loading, Unloading and  Transportation Charges	04
16-101003	as actulas	04
16-101003	Immediately within next working day after receiving the Purchase Order	05
16-101007	At the time of unloading the material ,sufficient time to be given to our store persons for the	06
16-101007	Quality & Quantity inspection, acceptance & unloading.	06
16-101003	Goods to be supplied against this order must be properly packed to avoid damage during Transit / Storage.	07
16-101003	Warranty valid for a period of  12 months from the date of supply.	08
16-101003	shall be done in presence of our company representative at your stock yard	10
16-101003	To be Obtained by the Supplier at not extra Cost.	13
16-101003	Any non-tendered materials shall not be supplied until the rates & sizes are approved in writing by the undersigned.	14
16-101003	Material should be supplied between 8:00 am to 6:00 pm on working days (Monday to Saturday).	16
16-101003	60 Days credit from the date of Delivery	90
16-101004	Inclusive of VAT@ 14.5%, Loading, Unloading and  Transportation Charges	04
16-101004	as actulas	04

While Loading the data I need to Combine the same LineNo.

Example: In the First and second Order LineNo is 4 So the Output will be.

Order Number    Header_text                                                                                                                    LineNo

16-101003        Inclusive of VAT@ 14.5%, Loading, Unloading and  Transportation Charges as actuals         04

Please help me with this.

Regards,

Keerthi KS

[tresesco · Accepted solution]

Try like:

Load

          [Order Number],

          Concat( Header_text, ' ') as Header_text,

          LineNo

From <> Group By LineNo, [Order Number];

[#3]

It gives Error. Below is my Script

TEPurchaseHeader:

LOAD

     Uniqueid as PurchaseHeader_ID,

     Order_Number,

     Concat(Header_text,' ') as Header_text,

     LineNo

FROM

[..\10_data_sources\PurchaseHeader.qvd]

(qvd) Group By Order_Number,LineNo ;

[tresesco]

Include the third field as well in the group by clause like:

...Group By Order_Number,LineNo, Uniqueid ;

[#5]

It shows invalid expression. Is there any mistake in Concat

[tresesco]

I don't see anything such. Could you post a sample?

[jagan]

HI,

Try like this

TEPurchaseHeader:

LOAD

     Uniqueid as PurchaseHeader_ID,

     Order_Number,

     Concat(Header_text,' ') as Header_text,

     LineNo

FROM

[..\10_data_sources\PurchaseHeader.qvd]

(qvd) Group By Order_Number,LineNo, Uniqueid ;

You have to use all the fields used in Load in Group by.

[pooja_sn]

ResultantTable:

Load 
Concat( Header_text, ' ') as Header_text,
[Order Number],
LineNo
resident InputTable
Group By LineNo, [Order Number] ;

DROP table InputTable;

[#9]

Sorry it was my mistake in the script. Its Working

[#10]

Can we concatenate based on Uniqueid Order ?

Uniqueid	Order_Number	Header_text	LineNo
1	15M-100895	1) Please issue the shop  drawing to our site team and get the approval	02
2	15M-100895	prior to work.	02
3	15M-100895	2) Conduite the cables as per the shop drawing issued by you.	02
4	15M-100895	3) Supply and installation of equipments in good condition.	02
5	15M-100895	Others	02

Concatenate should be on the above order(Uniqueid).

Regards,

Keerthi KS