Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I want to add additional row to existing fields

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

NameValue
Space17
9 Replies
cspencer3
Creator II
Creator II

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.

Chanty4u
MVP
MVP

u can create an excel sheet and do concatenate

Concatenate (samle)

Load * Inline [...

];

lik dis

Mark_Little
Luminary
Luminary

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

Not applicable
Author

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

Mark_Little
Luminary
Luminary

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

sinanozdemir
Specialist III
Specialist III

Hi,

What does your original dataset look like? Can you post a sample of it?

Thanks

Not applicable
Author

See attached. I wanna add until Class 55

Mark_Little
Luminary
Luminary

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);

settu_periasamy
Master III
Master III