adding columns using fieldvalues

[Anonymous]

Hi all

I get tables like this:

column names are always the same.

fieldvalues in column Name always start with DigitsDotBlankspace

The rest differs every time

ID	Text	Name
001	Great	1. Slovenia
001	icecream	2. Spain
002	blodpudding	1. Slovenia
003	donald thrump	2. Spain
002	lollipop	11. Finland

I whant to is to turn them into  tables lik this:

ID	Text	Name	1. Slovenia	2. Spain	11. Finland
001	Great	1. Slovenia	1. Slovenia
001	icecream	2. Spain		2. Spain
002	blodpudding	1. Slovenia	1. Slovenia
003	donald thrump	2. Spain		2. Spain
002	lollipop	11. Finland			11. Finland

Any ideas?

[marcelviegas]

hi,

load*,if(Name='1. Slovenia','1. Slovenia') as '1. Slovenia',if(Name='2. Spain','2. Spain') as '2. Spain',if(Name='11. Finland','11. Finland') as '11. Finland';

Original_Table:

LOAD * INLINE [

    ID,Text,Name

001 ,Great, 1. Slovenia

001 ,icecream, 2. Spain

002 ,blodpudding, 1. Slovenia

003 ,donald thrump, 2. Spain

002 ,lollipop, 11. Finland

];

[rwunderlich]

Use the Generic Load prefix.

Generic Load ID, Name, Name....

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes...

If you want to reassemble the tables into one, see the script at the end of this post. Use cases for Generic Load | Qlikview Cookbook

You'll also find lots of examples and discussion on generic load here in the forums.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[Anonymous]

Thanks for your help : )

Sorry for late answer.

/Måns