Transformations

[Anonymous]

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

[tresesco]

Try like:

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

Update: Added one more condition

[antoniotiman]

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

[vinieme12]

i think

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

[shanky1907]

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

[shanky1907]

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