Merging different records into one file

Hi,

I've some files with me which i want to merge on some condition.

Ex- i've 2 Fund file namely 51_returns and 51_stats . Then i've some one more file called 51_IMS

My workflow is reading both 51_returns and stats together . Another workflow is loading 51_IMS file. Both the workflows are connecting to different location and doing some different calculation .

But i'm combining both into single WF by joining based on fund id which is 51 in this case. I've attached sample files here.

I want all these input files records to be merged in one output attached.

Workflow

Accepted answers

grazitti_sapna

Hi @AnandKumar1 , give this a try.

Workflow-GS-V1.yxmd

afv2688

Helo @AnandKumar1 ,

Does this work for you?:

Regards

New Workflow8.yxzp

All comments

grazitti_sapna

Hi @AnandKumar1 , give this a try.

Workflow-GS-V1.yxmd

Qiu

@AnandKumar1
How to calculate IMS_IsPortorIndex?

AnandKumar1

if !IsNull([BaseMktVal]) and IsNull([IMS_BaseMktVal]) then 'Both'
elseif IsNull([BaseMktVal]) and !IsNull([IMS_BaseMktVal]) then 'Index'
else [IDH_IsPortorIndex] endif

afv2688

Helo @AnandKumar1 ,

Does this work for you?:

Regards

New Workflow8.yxzp

AnandKumar1

There is one more thing.

So for input file 51_IMS has a field ISIN=EUR. This EUR should join with both 51_returns and statistics file with ISIN=Blank. And this join output should replace the EUR value which came earlier after union.

How to achieve this?

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235