Split .xlsx column into a new column

[archienesss]

Hello,

I was wondering if I can ask for your assistance. I am hoping to create a new column based off of a row value. Below is the sample data:

Input:

.---------------------------------------------.
| tLogRow_2 |
|=-------------------------------------------=|
|AGENT_ID |
|=-------------------------------------------=|
|aagte500 (Aagten, Bastiaan ) |
|2019-11-20 00:00:00.000 |
|null |
|null |
|null |
|null |
|null |
|null |
|null |
|null |
|null |
|abdir502 (Abdirahman, Omar ) |
|2019-11-20 00:00:00.000 |
|null |
|null |
|null |
|null |
|null |
|adolf501 (Adolfsen, Betty ) |
|2019-11-20 00:00:00.000 |

Expected Output:

AGENT_ID	SCHED_DATE
aagte500 (Aagten, Bastiaan )	2019-11-20 00:00:00.000
aagte500 (Aagten, Bastiaan )	2019-11-20 00:00:00.000
aagte500 (Aagten, Bastiaan )	2019-11-20 00:00:00.000
aagte500 (Aagten, Bastiaan )	2019-11-20 00:00:00.000
aagte500 (Aagten, Bastiaan )	2019-11-20 00:00:00.000
aagte500 (Aagten, Bastiaan )	2019-11-20 00:00:00.000
aagte500 (Aagten, Bastiaan )	2019-11-20 00:00:00.000
aagte500 (Aagten, Bastiaan )	2019-11-20 00:00:00.000
aagte500 (Aagten, Bastiaan )	2019-11-20 00:00:00.000
aagte500 (Aagten, Bastiaan )	2019-11-20 00:00:00.000
aagte500 (Aagten, Bastiaan )	2019-11-20 00:00:00.000
abdir502 (Abdirahman, Omar  )	2019-11-20 00:00:00.000
abdir502 (Abdirahman, Omar  )	2019-11-20 00:00:00.000
abdir502 (Abdirahman, Omar  )	2019-11-20 00:00:00.000
abdir502 (Abdirahman, Omar  )	2019-11-20 00:00:00.000
abdir502 (Abdirahman, Omar  )	2019-11-20 00:00:00.000
abdir502 (Abdirahman, Omar  )	2019-11-20 00:00:00.000
abdir502 (Abdirahman, Omar  )	2019-11-20 00:00:00.000
adolf501 (Adolfsen, Betty  )	2019-11-20 00:00:00.000
adolf501 (Adolfsen, Betty  )	2019-11-20 00:00:00.000
adolf501 (Adolfsen, Betty  )	2019-11-20 00:00:00.000
adolf501 (Adolfsen, Betty  )	2019-11-20 00:00:00.000
adolf501 (Adolfsen, Betty  )	2019-11-20 00:00:00.000
adolf501 (Adolfsen, Betty  )	2019-11-20 00:00:00.000

My components for now are below:

tFileList -> tFileInputExcel -> tLogRow

I've tried using tSplitRow but I cannot filter out properly the date value type. Below are the mappings I've tried.

AGENT_ID

row1.AGENT_ID;

SCHED_DATE

(row1.AGENT_ID.contains("(")||row1.AGENT_ID.contains(")")||row1.AGENT_ID==null||row1.AGENT_ID.equals(""))?null:row1.AGENT_ID;

Please advise which component will be suitable for my need or if certain JAVA functions will be needed. Thank you so much for the help.