Have you noticed the ETL (beta) option?

Though I’m sure many of you knew this already, I didn’t so I’ll add that ETL stands for “extract, transform, load” and the new feature seems to allow us to import tables, though I haven’t tried it yet:

The tab is located inside of “Manage”.

5 Likes

While I still don’t see it in my version of editor, this must be an upgrade that pending to reach all of users.

1 Like

That’s interesting. I wonder why you don’t see it. It is still in my editor. Did you tap on “Manage” and the look at the tabs?

Yups, maybe just take times to get update to all users. Here is my tabs, few second ago.

2 Likes

New features are not usually rolled out to everyone at once.

2 Likes

Yep, I notices the ETL tab a few days back but it was just a “placeholder” - no functionality inside. I figured something was coming soon!

1 Like

Perhaps that part of the explanation for new features not being announced.

ETL is not yet released… so you need to wait for a while.

2 Likes

But its in BETA right. It seems to be functional though I haven’t actually imported anything yet. Heck, I’ll try it right now!

I’m not able to confirm that because for me it’s working already :slight_smile:

I had to lookup “ETL”, too. I’d never seen that acronym before. I feel like “Import” is more suitable for no-code, though.

2 Likes

It worked!

There was a bug right out of the gate. I had a DateTime column where some rows were blank. The import reported that it couldn’t convert those to DateTime. Once I applied a DateTime to all rows, they were imported.

Now, I am left wondering where this will be useful? Is this just a step towards an automated feature we can utilize within our apps? Does the import run App Formulas as well?

It seems just as easy to copy paste between sheets. BUT, I can see the benefits if this is from a sheet to a database or the reverse!!

1 Like

I tested it few days ago and it should calculate the app formula. Also… the initial value is calculated if the column is blank. And hope I’m remembering this correctly :slight_smile:

1 Like

Hi @Steve! As I wrote, the ETL acronym was new to me. But, it seems that the term has come up in this community a few times in the past:

https://community.appsheet.com/search?q=etl

1 Like

I have requested a feature like this a while back as a way to integrate with another application. I was told i should write a google script to do that. The problem with that was that app formulas would not work on the imported data.

1 Like