AnsweredAssumed Answered

Delimited text file, unique ID and additional fixed fields

Question asked by boomi_radiol on Sep 28, 2018
Latest reply on Sep 28, 2018 by rcasimina462530

Hello All,

 

We want to have a text file as output, where the ID_Employee is unique in each row of the file and the columns are fixed values, which could have data or not

 

Example format :

 

id_employe,Hour_type1,Hour_Type2,Hour_Type3,Hour_Type4
id_employe,Hour_type1,Hour_Type2,Hour_Type3,Hour_Type4

 

example data:

 

9999,10.00,20.00,00.00,00.00
8888,00.00,05.00,07.45,10.00

 

where

 

id_employe = unique

 

Hour_type1,Hour_Type2,Hour_Type3,Hour_Type4... are values fixed

 


Do you have any idea to create a profile for this format?

Outcomes