topic Re: adding columns using fieldvalues in QlikView

adding columns using fieldvalues

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: adding columns using fieldvalues

marcelviegas — Mon, 30 Apr 2018 18:26:30 GMT

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

];

Re: adding columns using fieldvalues

rwunderlich — Mon, 30 Apr 2018 18:51:24 GMT

Use the Generic Load prefix.

Generic Load ID, Name, Name....

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

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

Re: adding columns using fieldvalues

Anonymous — Thu, 12 Jul 2018 09:37:11 GMT

Thanks for your help : )

Sorry for late answer.

/Måns