2 réponses
- Le plus récent
- Le plus de votes
- La plupart des commentaires
1
Hi, The Scan command you are looking for looks like this:
aws dynamodb scan --table-name cust --query 'Items[*].stateHistory.L[*].M.state'
aws dynamodb scan --table-name cust --query 'Items[*].stateHistory.L[*].M.state'
[
[
{
"S": "confirmed"
},
{
"S": "active"
},
{
"S": "finished"
},
{
"S": "archived"
}
]
]
Or you can narrow it down further with:
aws dynamodb scan --table-name cust --query 'Items[*].stateHistory.L[*].M.state.S' --output text
aws dynamodb scan --table-name cust --query 'Items[*].stateHistory.L[*].M.state.S' --output text
confirmed active finished archived
0
Thank you! Exactly what I needed! 👍 I modified it slightly, so that the output in the text is easy to process via Excel:
...,(stateHistory.L[0].M.state.S),(stateHistory.L[1].M.state.S),(stateHistory.L[2].M.state.S),(stateHistory.L[3].M.state.S),(stateHistory.L[4].M.state.S)]" --output text> data.txt
Follow-up question: How do I add headlines to each data field of the data.txt automatically so that I can use them as column names in Excel afterwards? 🤔
répondu il y a 2 ans
Contenus pertinents
- demandé il y a un an
- demandé il y a un an
- demandé il y a 2 mois
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 9 mois
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 2 ans