Output Issue

[henrygeorge]

Hi Team, 

This is my Static Excel File with various names based on Region - 

APAC	LDN	NY	EMEA + ID contains "CAR"
Manish	Revanth	Ruth	Nithin

This is my Raw Data Input File - note it should not fill in those that already have an owner

ID	Name	Region	Owner
7845	ABC	APAC	[Null]
56253	DFG	LDN	[Null]
5456	FGT	NY	[Null]
ABC56	TYY	APAC	Ram
CARTB56	MAD	EMEA	[Null]
5454	ITC	EMEA	[Null]

This is how I want the output to be like - 

ID	Name	Region	Owner
7845	ABC	APAC	Manish
56253	DFG	LDN	Revanth
5456	FGT	NY	Ruth
ABC56	TYY	APAC	Ram
CARTB56	MAD	EMEA	Nithin
5454	ITC	EMEA	[Null]

How do I get this output? Especially with conditions like contains in the static file?

Please do help.

[Assaf_m]

Hi,

Attached is a solution for your problem, 

Note that the last record in your output is showing [Null} where it should show Nithin.

Please check and let me know if it works.

[OllieClarke · Accepted solution]

Hi @henrygeorge If you restructure your header file, you can use the dynamic replace tool to get what you want