You are not logged in.
Correct.. I was not getting the part of the "dir_" part.. It's working fine now.
Thanks a lot for all the help.
Because the column name in your job is Folder_Name, the expression should be Folder_Name_tMemorizeRows_1, Folder_Name_tMemorizeRows_1.
Here you go... Thanks!
Please notice the Limits: 20 images per post, each image must be less then 1024x768 pixels and 200 KB.
Please upload a screenshot about the settings of tMemorizeRows.
Thanks a lot for the reply.
How to you get the last part, in the tMap, to work?
I'm getting "dir_tMemorizeRows_1 cannot be resolved to a variable".
The following images will explain it.
I'm processing a csv file that contains one field that has a folder hierarchy like:
This a folder list that I need to import to a table like:
FOLDER_ID | PARENT_FOLDER_ID | FOLDER_NAME
So I need to parse each of the rows in the csv file into something like:
PARENT_FOLDER | FOLDER
FOLDER1 | FOLDER2
FOLDER2 | FOLDER3
FOLDER3 | FOLDER4
... so that I can insert it in the database.
Any ideas to solve this?
Thanks a lot!