[VIDEO] How to validate and transform email messages.

Every time I see transformations with so many steps , my heart races ! I always feel like optimising, I absolutely wold have run a calculation using Python and chatgpt to give the output in a single line with semicolon as delimiter and then split using delimiter  ; to get multiple output 

I really need to trust AETL to run complex transformation 

 

Well we did try to use Spilt function first but the fields order is inconsistent.
So we had to use slightly more complex approach.   

what I mean is using a single / multiple 'Calculation' field to strip , delete and transform and get the output in single window, then using split on delimiter 

Could be a good opportunity to showcase another video  as chatgpt player real nice with AETL python calculation with instructions (I posted them earlier) 

Python Script Guidelines for ETL-Tools

Execution Rules
- Write top-down scripts; no main() or function wrappers.
- Final output must be assigned to Result.value (case-sensitive).
- Do not use print().

Input Handling
- All inputs are strings by default.
- ETL-Tools variables like [F001], [F002], etc., can be used directly.
- Convert inputs to the required types as needed.

Notes
- Do not initialize Result; it’s provided by ETL-Tools.
- Use ETL variables directly in expressions—no need for intermediate assignments.

---

Example: String to Array + Condition

python
input_string = "3;"
array = [int(x) if x else None for x in input_string.split(]

if array[0] == 1:
    Result.value = "YO"
elif array[1] != 1:
    Result.value = "BB"
elif array[2] == 3:
    Result.value = "DD"
else:
    Result.value = "No condition met"


Example: Using ETL-Tools Variables

python
result = int([F001]) + int([F002]) + 100
Result.value = result

Could be a good opportunity to showcase another video  as chatgpt player real nice with AETL python calculation with instructions (I posted them earlier) 

That would really great.