Drop files to upload
{{ (currentUser.username || 'AD').substring(0,2).toUpperCase() }}
{{ currentUser.username || 'Loading...' }}
{{ currentUser.role || 'GUEST' }}
Portal
Dashboard
Data
Creator
Workflow
Team
{{ clock.time }}
{{ clock.dateOnly }}
{{ currentSourceName }}
System Folders (Protected)
{{ item.name }}
User Files
{{ item.name }}
{{ tab.name }}
Advanced Query Builder
Save Code
Presets
System Presets
Basic: Merge All Files
My Presets
{{ p.name }}
Output:
{{ activeTab.outputFolderName || 'Select Folder...' }}
.csv
.xlsx
RUN
STATUS LOG
{{ contextMenu.item.name }}
Rename
Download
Delete
Advanced Query Builder
Categories
{{ cat.name }}
1. DATA SOURCE
Add Source Column:
None
Use File Name
Use Sheet Name
{{ idx + 2 }}
{{ getOpName(step.type) }}
Help
{{ getOpGuide(step.type).title }}
{{ getOpGuide(step.type).desc }}
{{ getOpGuide(step.type).example }}
User ID Column
Date Column (Transaction)
Group By (User)
Sort By (Date)
Output Column
Target Column
Group By
Sort By (Date)
Function
Rolling Sum
Rolling Avg
Running Total
Lag
Days
Time Range:
All Time
Relative (Last N)
Fixed Date
Last
Days
-
Output Name
New Column:
=
+ Add Rename
New Column Name:
IF
==
>
<
>=
<=
Has
THEN
ELSE
+ Add Else-If
To Date
Substring
Combine
Asc
Desc
Keep
Drop
AND
OR
=
>
<
Has
+ Condition
Sum
Avg
Count
Min
Max
+ Calc
{{ op.name }}
Save Preset
Cancel
Generate Python Code
Select Output Folder
{{ item.name }}
{{ item.name }}
Selected:
{{ outputModal.currentFolderName }}
Choose This Folder
New Folder
Folder Name
Cancel
Create
Success!
Saved to:
{{ activeTab.outputFilename }}
Close
Open in Workflow