topic Re: Transformations in QlikView

Transformations

Anonymous — Mon, 23 Oct 2017 07:55:39 GMT

Hi All,

If column Assigned Group = end with ’- aaa’ then display in column Assigned Support Organization ‘Applications – aaa’ instead of A.

Ex: Raw data

Assigned Support Organization	Assigned Group
A	Apps Mosaic - Finance - aaa
A	Apps Mosaic - Finance - aaa
B	Apps Mosaic Project Warranty Finance - aaa
B	Apps Mosaic Project Warranty Finance - aaa
B	Apps Mosaic Project Warranty Finance - aaa
A	Apps Mosaic - Finance - aaa
C	PMO

Required format :

Assigned Support Organization	Assigned Group
Applications – aaa	Apps Mosaic - Finance - aaa
Applications – aaa	Apps Mosaic - Finance - aaa
B	Apps Mosaic Project Warranty Finance - aaa
B	Apps Mosaic Project Warranty Finance - aaa
B	Apps Mosaic Project Warranty Finance - aaa
Applications – aaa	Apps Mosaic - Finance - aaa
C	PMO

Thanks,

Krishna

Re: Transformations

tresB — Mon, 23 Oct 2017 07:58:17 GMT

Try like:

If( WildMatch([Assigned Group], '*aaa') and [Assigned Support Organization]= 'A', 'Applications – aaa' , [Assigned Group] )

Update: Added one more condition

Re: Transformations

antoniotiman — Mon, 23 Oct 2017 08:08:33 GMT

May Be this

LOAD [Incident ID],
Status,
[Status Reason],
[Submit Date],
[Age of Incident (days)],
Company,
[SLM Status],
If([Assigned Support Organization]='A' and Trim(SubField([Assigned Group],'-',-1))='aaa','Application-aaa',
[Assigned Support Organization]) as [Assigned Support Organization],
[Assigned Group],
[Last Modified Date],
Priority
FROM
https://community.qlik.com/servlet/JiveServlet/download/1366610-300659/sampledata.xlsx
(ooxml, embedded labels, table is Sheet1);

Re: Transformations

vinieme12 — Mon, 23 Oct 2017 08:41:36 GMT

i think

if([Assinged Support Organization] = 'A' and WildMatch([Assigned Group], '*aaa') , 'Applications – aaa' , [Assinged Support Organization] )

Re: Transformations

shanky1907 — Mon, 23 Oct 2017 09:03:58 GMT

Please Take Calculated Dimension in place of your Dimension of 'Assigned Support Organization' and you can use the below code in its definition:

If([Assinged Support Organization] = 'A' and WildMatch([Assigned Group], '*aaa') , [Assigned Group], [Assinged Support Organization] )

Re: Transformations

shanky1907 — Mon, 23 Oct 2017 09:10:03 GMT

And use the name of this Calculated Dimension as: Assinged Support Organization