Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a field, and dont have access to the field I wanna add the field name and value to the next row respectively.
some thing like this
Name | Value |
---|---|
Space | 17 |
I'm not sure I fully understand your situation, but you could concatenate any data you want to that table in your load script using "
Concatenate(Table_Name)
***insert load statement here***.
"
You can even do this with an Inline load or a normal load from a usual source.
u can create an excel sheet and do concatenate
Concatenate (samle)
Load * Inline [...
];
lik dis
HI,
Looking at the example you probably want to use the apply map.
Map:
Mapping Load
Name,
Value
From 'Table';
OringalData:
Load
...
ApplyMap('Map', Name) AS Value
From OrginalTable;
Mark
All These doesnt seem to answer my question. I have series of fields in a report I wanna add a new row to it thats all
Hi,
Can you supply some more details then please?
What is the data like you have loaded already?
What is the data you want adding?
How do you want it to look afterwards?
Mark
Hi,
What does your original dataset look like? Can you post a sample of it?
Thanks
See attached. I wanna add until Class 55
Hi,
If it is literally just adding to the bottom then concatenate.
In the example supplied
LOAD CLASS,
PO,
GROSS,
NET
FROM
[\Book2.xlsx]
(ooxml, embedded labels);
Concatenate
LOAD CLASS,
PO,
GROSS,
NET
FROM
'Other Place'
(ooxml, embedded labels);
May be look here