Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try like:
Load
[Order Number],
Concat( Header_text, ' ') as Header_text,
LineNo
From <> Group By LineNo, [Order Number];
Try like:
Load
[Order Number],
Concat( Header_text, ' ') as Header_text,
LineNo
From <> Group By LineNo, [Order Number];
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 ;
Include the third field as well in the group by clause like:
...Group By Order_Number,LineNo, Uniqueid ;
It shows invalid expression. Is there any mistake in Concat
I don't see anything such. Could you post a sample?
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.
ResultantTable:
Load
Concat( Header_text, ' ') as Header_text,
[Order Number],
LineNo
resident InputTable
Group By LineNo, [Order Number] ;
DROP table InputTable;
Sorry it was my mistake in the script. Its Working
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