Clean up your Tables Quick and Easy!
Sometimes you import some data that looks like this:
But you want table data that looks like this:
This script does that:
let settings = input.config({
title:'Table Optimizer',
description: "Converts data that's stored over many fields, into data that's stored in one field with multiple parameters in a new table",
items: [
input.config.table('sourceTable',{
label: 'Source Table',
description: 'The originating table'
}),
input.config.text('fieldsConvert',{
label: 'Fields to Convert',
description: "Type out the fields you'd like to convert separated by a comma. Example: Field 1,Field 2,Field 3. All convert fields must be of the same type."
}),
input.config.table('destinationTable',{
label: 'Destination Table',
description: 'The desitination table'
}),
input.config.field('field1',{
label: 'Data Field',
parentTable: 'de
