Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
How to create a new column with 2 Fieds like below.
Tab:
Name,
Dept
From
C:Tab\Tab.qvd;
I want the new column needs to add with 2 fields
Like -
RegApproach(New Column)
US
PRA
I tried like below
Tab:
Name,
Dept,
'US' as RegApproach
From
C:Tab\Tab.qvd;
But I can't add PRA field
Is this coming from your data source like this an you need to split USPRA?
Can you attached your file/data?
No Data in source,
Its just like flag, need to add additional Column with US and PRA
RegApproach
US
PRA
Is there any way without Inline load
Hi Use,
Load
Inlinr
[
RegApproach
US,
PRA
];
Im, not sure if that what you want.
Try this if this ok 4 u
Tab:
'US' as RegApproach
From
C:Tab\Tab.qvd;
concatenate(Tab)
Load
'PRA' as RegApproach
resident Tab;
Hi Harsha,
I have done the same as below. No concatenate required as same field. But I just trying to get in one table.
'US' as RegApproach
From
C:Tab\Tab.qvd;
Inline Load as below
RegApproach
PRA
Yes Noconcatenate required but if you share your purpose of doing appending without above methods may be it will help for alternate approach...
Hi Priya,
it looks like you want to create 1 new column that contains 2 new values, but these need to be added to existing records in the table TAB, have a look at the example attached to see if it helps.
Regards Andy
Here you go:
TAB:
LOAD * Inline [
Name, Dept, From
Name1,Dept1,From1
Name2,Dept2,From1
Name3,Dept3,From1
Name4,Dept4,From1
];
Join (TAB)
Reg:
LOAD * Inline [
Name,RegApproach
Name1,US
Name2,PRA
Name3,US
Name4,PRA
];
Andy
Same way I have done...
Just checking without inline load can we create column in the same table. but its good