store the dynamic values in context variable

[Anonymous]

Hi team,

I have source oracle table and there is one column called txn_date. 

values are:

txn_date

02-06-2017

04-06-2017

07-06-2017

04-06-2017

Requirement: How to create folder based on date for examples:

folder 1: c;/Txn_dt_02-06-2017/

folder 2 :c:/Txn_dt_04-06-2017/

folder 3 :c:/Txn_dt_07-06-2017/

But no duplicate folder even if same records with same date arrive. 

and is possible to store single context variable  to store unique txn_dt values?

Thanks

Shree

[Anonymous]

Hi,

Sure, Let start work on it. let you if i face any issue.

Thanks

Shree

[Anonymous]

Sure, i will start work on it, let you know if i face any issues.

Thanks

Shree

[Anonymous]

Hi,

I have attached job screen shot.

(1)tOracleInput -->(2)tMapRow---> (3)tFlowToIterate ---iterate--> (4)tOracleInput -----> (5)tFileOutputExcel

tOracleInput_1 : "select distinct txn_dt from REC_TAB_MTN_CBANK"  // Got 2 distinct dates

I have used tmap: Just pass though.

tFlowToIterate : Just pass though.

tOracleInput _2: i can see two time executed. 

tFileOutputExcel: checked (Create directory if doesn't exist)

"C:/Users/DELL PC/Desktop/out.xlsx"+((Integer)globalMap.get("tFlowToIterate_1_CURRENT_ITERATION"))

Output: two files are created.

No folder created.

The files created not xlsx format. 

I not good in global map, i am missing this one. Can you help me on this.

Thanks

Shree

files format.PNG

[Anonymous]

Hi, 

May i know input and suggestion for next step. 

Thanks

Shree

[Anonymous]

This is working as you have coded it. The two files have been created on your desktop. The following code.....

"C:/Users/DELL PC/Desktop/out.xlsx"+((Integer)globalMap.get("tFlowToIterate_1_CURRENT_ITERATION"))

.... is creating files called "out.xlsx"+{the iteration number} to your desktop. If you want folders to be created you have to change this path to the path you want to create.

[Anonymous]

Hi,

I have changed folder path. No expected result.

I have attached screen shot your references. 

Observation:

1) File Output format  is wrong. ( .xlsx1 )

2) Both file is same means same records are passing both files. it's not inserting the records based on txn_dt.

3) No folder are created based on txn_dt.

Thanks

Shree

wrong data created.PNG

[Anonymous]

Hi,

I am sharing job documentation. It will really help for find out problem.

Please find the attched xip file. Open Mutiple_Folder_0.1 (HTML file)

Thanks

Mutiple_Folder_0.1.zip

[Anonymous]

Hi,

Please ignore last attached file. Find the latest attached zip file.

Thanks

Shree

Mutiple_Folder_0.1.zip

[Anonymous]

Your file path (the thing I mentioned in my last post) is wrong. You are not using the same logic as before. Regardless of the content of the files, you need to sort that files and folder right first. The file path must include your date folder and you seemed to have this working in the past. Go back to how you calculated the path then.

The reason you have 1 and 2 after the ".xlsx" file extension is because you are appending the current iteration value. 

[Anonymous]

Hi,

I have messed lot of things here.

Could you please created job and share with me, let me check where am doing wrong.

Thanks

Shree